SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503200 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503200 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108673,805842,1035772,638917,444144,486333,758979,111851,443598,26290,89558,999669,277460,980386,210228,575568,392523,177575,398370,646220,872459,854047,962346,958446,261528,181518,700552,318005,623879,932693,958161,188609,771477,593228,212526,517091,627686,58747,965996,787898,557811,866155,430775,458353,562675,923410,419088,293058,663088,698674,518155,48286,831453,275168,824349,777216,957599,949965,270816,228775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]