SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59121 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59121 [ RunTime:0.003318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106779,537722,102238,1026747,258138,500478,801453,418218,310665,851695,117100,343138,1011945,173904,818227,715899,13461,726688,370911,612494,235233,413837,456993,228273,452991,408133,419754,155516,211309,52673,814714,105890,677059,132850,384439,637902,120577,493477,437138,993219,81628,80139,987270,313636,525077,292089,94895,999755,131907,320674,924170,871715,736834,1022892,362266,717177,438943,145394,780319,506650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004696s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]