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` = 106800 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106800 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198847,742418,582350,593980,870575,811590,32408,114860,195594,185606,145879,72465,122620,363609,586759,591596,450323,66309,723308,987692,618083,122213,841495,298034,937007,16861,810026,465453,941853,228446,914999,140120,690909,346436,947830,247967,796334,620427,925624,545554,394301,257386,609199,648482,352271,559735,52567,82485,169514,76571,916873,295900,884235,835771,799128,909069,382142,147320,247873,903499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]