SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536186 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536186 [ RunTime:0.003400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265909,607060,702567,148499,841709,1032621,71563,883321,969330,558382,336272,807383,767535,344445,161951,17784,693428,805513,295709,966053,1032033,1001308,691147,1028156,384271,273031,711256,1036892,878112,910407,752802,783900,927182,396560,970060,18205,1034061,703948,865568,665469,319299,551390,561443,121034,812839,259156,708919,387687,182949,1371,855938,822584,232465,764974,883402,100261,437163,625804,494632,873351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]