SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199006 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199006 [ RunTime:0.003372s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511489,180365,492728,169735,843294,515427,63409,397820,350139,630364,402056,146528,549857,461306,966429,131763,975108,275091,371833,54062,18787,392759,40935,458280,110596,996621,961914,482011,112495,31917,642997,314615,941698,731276,453623,294081,84309,131466,1013196,978491,777280,487035,200261,730293,712854,210458,919618,263355,836604,320684,605560,245279,681823,31113,52946,945210,509955,298362,531138,423963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]