SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002528s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548843 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548843 [ RunTime:0.003792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406461,852014,744966,852523,174983,261328,985710,878301,19055,692667,306560,639499,866120,209943,151874,698128,73793,603340,408415,1048925,304561,715002,131463,993554,230562,249668,861617,772510,652675,222225,307911,658005,624945,564198,229726,966364,967693,981577,30205,393332,341535,986491,912817,190604,459118,538642,1031902,688592,549516,641245,144448,930901,977040,975608,376016,996286,687771,964005,462957,810308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]