SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 780203 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 780203 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450014,4691,1014126,411351,571376,218249,859318,723851,710061,733844,513000,743379,468674,950438,50207,104070,977704,202450,830076,483813,521560,945004,219799,956689,432324,224434,97249,724502,381958,445308,744978,301775,301386,156826,464104,415,87520,108995,723864,757324,175267,658886,956238,404205,894254,351959,562026,541738,96164,281206,746250,367222,898779,80422,854557,846195,690224,322720,26434,208266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 780203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 780203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]