SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293103 LIMIT 1 [ RunTime:0.002396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293103 [ RunTime:0.002354s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592627,711138,494842,609874,967281,11744,1027011,851367,16244,330348,2672,102926,50296,160714,351322,874244,294083,442691,340138,3125,235424,870228,566569,59620,244811,665040,689444,983218,964043,54983,785629,267430,113748,109036,856910,157426,74156,306047,991328,230732,802949,701256,774348,616390,786880,339666,901168,135549,866879,527809,355809,738014,234535,861451,386148,59773,507487,1028309,882323,361796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]