SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427616 LIMIT 1 [ RunTime:0.005457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427616 [ RunTime:0.003731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45059,263740,227138,943629,738648,673890,1013529,75496,253082,552503,273352,380694,210935,202500,814572,405937,492775,117235,924215,411186,423773,724135,462932,711311,1027530,83574,688685,640657,964168,1044497,496326,997104,358033,375901,1038515,712068,779169,892931,603429,1020830,802989,983568,439755,31713,799085,701276,9192,925536,375695,519855,211194,284831,580892,568947,601779,197385,186005,42022,984963,699031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004695s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]