SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470580 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470580 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674892,859821,388022,869365,21425,224099,678049,160854,397505,381640,648046,341844,653614,935733,275869,662852,628890,14299,313248,204250,599412,225793,468284,277930,86319,158933,688622,311124,293690,121145,891959,665000,118248,791339,488400,125453,89474,737594,400964,200702,920613,63804,750679,893059,431074,312585,874193,270412,477734,891420,213226,25585,952583,9106,788559,414793,346423,75757,706274,136364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]