SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001646s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010218 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010218 [ RunTime:0.008594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047427,495009,605477,82020,441608,710912,862547,211575,491234,534377,180208,132745,832683,979073,811873,380673,421015,828767,132705,155394,395441,234833,492972,299602,743788,715703,522434,780556,902845,1020202,650659,779529,494023,719116,596288,275168,971941,889848,270619,641572,1041840,660549,775388,173879,303899,531769,237324,845043,238549,425957,711916,320447,168888,115904,391280,998167,107722,369073,965701,519732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]