SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45103 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45103 [ RunTime:0.003437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388406,408475,1006804,934063,593298,453999,508233,419753,74941,262906,330084,559133,160798,377324,634254,39927,466247,347627,908426,927494,221445,33872,927568,119359,812989,305484,672417,539667,816835,128584,535658,601410,594795,81148,370791,840228,689245,223586,881305,53067,974344,835862,176438,862796,889103,782699,692391,370113,201137,454296,13060,964590,436437,351186,542721,8858,535707,123240,853223,34581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]