SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268691 LIMIT 1 [ RunTime:0.001288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268691 [ RunTime:0.002375s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296100,845413,567555,396860,901311,206327,568805,458197,392354,678382,400110,229750,903922,211990,876369,360779,748000,174757,669385,423385,234011,217875,167411,806946,595488,61511,585639,216699,654107,543482,345275,627033,196272,265206,90891,1036697,776330,255640,13692,205520,402787,434315,47597,72114,62535,84543,306907,792847,290819,927930,305882,657592,785253,788064,85385,376122,657994,918753,264837,536668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]