SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031648 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031648 [ RunTime:0.002156s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942120,868889,693308,867233,786101,242738,125307,654927,143776,421682,565395,950639,187679,838328,390517,620099,669814,59899,85395,396712,1034396,662332,282307,674515,203167,698287,165810,989854,429798,457923,689065,200621,704457,566289,994473,46434,374329,889860,282580,825002,294894,658087,464535,684422,33229,487252,180757,601756,767397,672727,901754,285123,211662,860524,977718,166524,844399,574702,121315,688221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]