SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382300 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382300 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581734,15353,901439,973989,68109,709598,262484,892654,857596,132821,756261,750495,22651,480301,780622,500813,679342,271706,300481,30016,19445,299377,597364,356407,89076,298234,978705,920680,214663,138680,729016,979324,795128,967215,773680,500968,989918,424547,416332,566036,378855,1028485,700476,213279,321234,458927,658738,788750,902524,309167,886782,555154,276374,2568,337785,856443,561031,584309,392431,474352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]