SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514311 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514311 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116837,607826,108732,892001,1035735,339370,952852,232534,732025,298074,753398,755548,734582,701202,305776,728212,136363,364127,93686,702289,1033009,910506,964748,68987,204198,15189,1048427,944032,432881,552914,51020,1007227,721667,53445,751239,678635,345727,228222,592363,288531,115491,705568,72791,713152,517573,683283,285302,564413,522490,15163,416246,379167,805637,18396,348773,206735,913481,404230,203148,481859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]