SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283180 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283180 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827047,499023,911819,454312,126453,482677,846514,504793,468205,15920,756014,581660,485568,836120,637569,282621,507841,271159,700861,628221,310264,643983,36676,493360,651150,127145,277892,372312,85970,232281,884219,46996,1018260,447417,412582,1041629,674279,234170,153545,479371,315333,767551,188708,263339,260253,135038,250789,751107,832316,164948,398731,77283,1021367,163283,44253,512981,279175,1030701,388158,579941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]