SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539509 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539509 [ RunTime:0.002260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (67014,751035,221288,341796,286653,435600,557784,671788,886818,709632,1025790,682996,449634,948239,448384,13734,512143,885079,105646,207208,41507,719305,69373,990004,232079,1022562,116218,665455,684881,1030942,999422,14308,405975,111845,348457,642888,110128,608747,770246,653437,343670,956232,18202,387705,461325,559746,544007,791867,650063,679634,196317,165628,1019148,191178,166891,383576,141021,883539,73100,323820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]