SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397030 LIMIT 1 [ RunTime:0.002560s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397030 [ RunTime:0.005879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530849,347610,595387,713800,752721,628816,1029754,859739,342053,602109,999596,1018326,961291,361171,271341,232061,935841,801849,871500,406416,286017,1010140,907144,908965,284688,385476,827262,880020,11024,202475,25903,1024157,734009,1000710,865028,584876,507053,334730,47986,654471,358497,569499,219515,245048,951562,128683,336525,918078,352622,184340,820530,1024052,714602,306105,639175,68709,1041554,932275,689843,84487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]