SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001611s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 171313 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 171313 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143759,166819,152663,92949,875679,142860,1043255,511772,1036876,975303,9889,366326,616768,542095,150653,361431,965153,706349,263342,797157,696326,850690,656044,866434,685243,136462,824534,156558,798648,683092,628144,998553,382270,164533,394009,396884,480095,728823,729911,240471,388690,607079,707988,457753,977441,925439,725682,314581,819322,533225,579339,940013,49728,369333,425201,636578,164403,970095,405133,35464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 171313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 171313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000731s ]