SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681455 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681455 [ RunTime:0.003158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629835,781126,302365,799931,223864,827892,232341,142421,734988,92746,484509,543712,224659,293790,608843,497080,866772,567571,1043068,241816,839424,542608,381096,469073,476534,891583,1047113,373127,1034760,180868,289265,909585,67489,448885,938817,239201,293637,657938,713544,389290,31152,698766,415153,369493,24336,806999,583802,11965,960355,266306,8214,401717,268495,929800,492833,439940,960783,639470,611308,42171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]