SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014301 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014301 [ RunTime:0.007578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (957796,544747,3649,208964,969004,814030,670371,522437,100551,742333,447097,275518,209875,900507,675373,588305,463898,268700,246987,288909,376989,369024,759214,734888,487267,685167,993985,110810,660985,556301,767785,466219,405168,1014741,452281,143126,619898,314643,362024,723635,873712,890883,1038711,642829,596053,955888,834888,644772,1017269,215290,741199,121086,649917,369733,711745,499431,443579,795654,35749,638434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]