SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283343 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283343 [ RunTime:0.002346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044913,190601,135236,698069,553042,864104,505647,673383,713018,277069,318101,957799,508150,10919,1026636,411917,79555,571774,986403,622683,281418,331794,698670,582622,229985,556556,231265,241642,1010727,692020,571218,114749,564423,633603,292433,468447,106915,260393,873499,574567,529911,540618,356180,612714,461581,427767,855480,910267,950865,167282,964695,988271,290633,462811,758396,205458,989417,809386,750771,18657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001148s ]