SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56204 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56204 [ RunTime:0.001474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863588,975770,158879,827673,364585,929992,967072,6955,726252,57921,60713,1032487,531369,120540,1021915,919198,203787,1045858,89029,703055,972451,82377,371217,966045,917824,684204,467446,964682,577595,257343,88845,823522,256007,281164,892148,202924,45499,79156,395977,1009310,875280,1012647,894778,172700,721363,95265,37925,291674,768017,1944,908312,683023,1024960,24933,64818,735802,228945,520761,63972,1041708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]