SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541321 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541321 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913820,953303,640063,84357,353798,586777,941942,26388,1015223,367807,455483,127499,352855,734605,198044,989561,700350,215071,532655,101373,752938,498230,650034,752648,945079,631251,72964,125802,589909,1001944,23255,805168,707733,13959,609722,686143,418655,319560,658823,164026,1030970,952728,568587,247560,852321,345041,482704,167541,305638,386185,491316,798255,966905,414250,78207,84253,693127,101949,165670,695251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]