SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011892 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011892 [ RunTime:0.002727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525971,1019992,318200,302881,852731,690295,670860,951816,828848,914442,198053,880109,990621,640296,619964,1026591,326383,762655,908526,205959,52954,167866,1030231,452963,550887,416080,114128,4699,563021,1036596,118472,824242,400121,498040,266971,206108,5458,639302,228570,472730,25796,131913,439047,945483,197608,759856,200438,817098,461441,574148,309920,1024324,75164,905897,883900,275255,697340,589346,126324,656984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011892 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011892 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]