SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015056 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015056 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509231,19681,409168,135971,749685,7205,833024,968090,822511,376915,548784,871154,743632,417141,321466,66418,746623,1048910,472324,706936,513631,1001464,194743,1018687,181171,113766,239481,93124,428330,530433,434126,387074,576422,607856,930040,187067,1035073,514600,745706,777915,912170,319920,410805,971652,490821,73874,413678,429738,249094,988746,992910,506888,155954,32546,618527,246752,375000,741456,673971,773962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]