SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521701 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521701 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468508,853840,1031791,984252,705862,192153,768046,214733,165631,389957,34361,455424,626905,969220,663815,57571,450696,598880,575267,433521,418791,977598,977750,194953,662722,688582,484114,813514,235919,960981,875463,843470,939609,537377,404068,206451,690701,834340,426136,955555,123141,402738,256418,1001026,1027472,611837,141525,706867,247790,370301,510061,192944,600402,133285,831585,490936,447821,609650,251994,926488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]