SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390591 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390591 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408520,447170,985647,603563,893304,349661,600138,1027071,199174,155521,504990,885994,763877,205584,1036164,106647,740487,1045648,100984,362902,105110,292765,737363,173665,736590,176290,674439,519347,898244,750047,571526,471392,144973,381723,781795,448557,449415,519823,1015752,204402,512494,1029661,879449,139985,532413,617965,697343,779265,510075,627364,99885,980476,514572,796527,242124,142627,435012,31228,721141,691922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]