SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203413 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203413 [ RunTime:0.002928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100840,89413,534109,326720,199210,446652,962010,964901,675510,312865,150141,883749,364713,152613,102521,645401,944705,548041,6905,867521,320223,715794,608393,211893,647254,820991,381255,818441,22942,69120,391130,958334,764372,762143,30072,895024,302829,476681,382152,695719,1037117,262076,601911,142671,486065,294734,366046,187962,179158,394953,506727,532690,696088,198632,196237,191011,964209,549443,83618,753889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]