SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012191 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012191 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (227115,538271,354781,120832,596603,490856,254506,756931,987837,695449,967027,388870,259683,416981,980562,803756,946863,980393,371765,865622,800718,56768,893466,834002,992191,754501,792465,356884,585773,990435,488744,770688,1012305,768763,978685,123619,275589,103369,526328,730232,442963,280975,612945,521430,442803,1010234,513236,488611,547722,891693,908722,756756,2845,599712,513853,140304,256231,27873,604356,728700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]