SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 582628 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 582628 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415726,588850,165785,273403,590198,576118,409611,300388,456978,611825,85302,629440,824270,123089,752873,533762,366648,745001,587048,804858,974581,874748,542871,688137,340977,293412,698788,147551,733343,356955,297642,214530,319599,605441,670762,842298,245554,821207,108446,321320,480896,21140,1027123,941683,492213,445892,21512,437164,325239,426868,149550,383974,358958,228013,433538,977530,596114,417103,975235,833631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 582628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 582628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]