SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264810 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264810 [ RunTime:0.002690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472847,391706,1013176,866808,812406,247345,673919,23868,52964,697571,588923,874374,191912,728615,34561,47377,668462,270423,212895,841359,153998,538225,603000,629553,772903,120441,579302,666452,756545,845559,83237,142162,50570,497866,376635,788952,148531,594098,200949,889402,391615,1006612,806951,500481,156455,681750,517293,372698,197022,183927,614994,757343,48453,558160,597289,185104,116609,1026169,297084,260591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]