SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012501 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012501 [ RunTime:0.004935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (781303,656306,648321,780260,367245,738105,987065,75225,94448,363210,986122,751888,127531,1034958,138219,771737,97232,636705,1008950,350503,401489,264060,41261,759599,19348,982043,354792,166743,684156,281402,303527,623294,593522,844362,737934,604672,476873,305182,278403,738297,309106,937795,214674,998311,222187,20614,91905,516570,791371,236364,337657,414599,896698,829273,382432,457438,53362,853735,761187,318489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001417s ]