SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001557s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022894 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022894 [ RunTime:0.002018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140590,68883,498939,985021,454916,790089,604569,438880,827142,551405,488103,114227,688582,949291,149387,503575,428012,728927,525250,211096,365526,670704,520529,545137,656906,265375,420964,112765,984928,491735,316278,487151,862918,284914,195785,178581,1027690,65947,500807,43511,653421,466990,323246,33888,426026,198262,601647,1018362,34009,513799,429841,313769,305592,108131,418857,835236,163518,326067,10615,490281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]