SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408230 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408230 [ RunTime:0.002512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262670,558207,71289,876643,229866,274813,308903,922592,76238,310216,873058,281061,927028,440436,242958,254553,994693,284695,348642,718737,345021,34332,1015094,421242,623995,78375,869863,177050,339238,1025032,952417,757492,673079,373125,627672,1004263,639815,923752,16716,1023285,933433,528265,120537,354149,284580,207808,193985,990529,315426,966546,487087,582247,659395,922507,510440,199666,20517,1006619,44414,763473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]