SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438521 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438521 [ RunTime:0.005196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459159,917674,995102,1012363,899265,600974,265795,60775,376469,510774,561213,360401,435040,296560,238413,693915,266624,584346,66710,595479,981656,302153,854803,230454,235598,994321,289573,1015320,264528,623052,59390,13912,738406,448461,175262,609934,200978,635033,444982,978178,834128,924975,264490,21194,501320,760088,230503,572204,841301,335427,39865,99948,387835,938140,332026,147451,562248,332095,55505,329126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]