SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548418 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548418 [ RunTime:0.003085s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47508,780010,683041,1037744,1010764,688129,211803,511456,273888,132657,856063,524830,252846,482715,891017,490313,15806,925338,211974,364859,1027871,836933,932583,812363,958931,846254,737084,798179,1019928,836797,855007,393077,352664,204596,234188,559188,655740,98976,666834,377424,291386,288159,845748,796991,707333,326798,993684,975689,850535,413790,878762,388941,91588,924708,421663,352360,461521,304311,372397,38301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]