SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403496 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403496 [ RunTime:0.002233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (626305,749809,765388,733267,1010805,879542,488839,781790,495218,490684,654901,609280,166799,411421,714657,770617,390574,974789,666759,413439,806438,1042167,121380,634653,279270,215633,674189,296326,875749,445328,822128,791778,95751,398022,1017995,476719,170992,718596,1046875,939159,362280,828103,791919,15212,527639,192188,427538,69901,115617,281860,44081,413835,166517,796731,951029,747035,156867,423919,955987,760071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]