SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540596 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540596 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988426,658461,676507,414986,797959,652946,385736,238790,818708,589377,3084,302381,795814,372570,2004,173580,818201,267898,33901,453313,549794,732912,975497,361202,640339,156477,894389,181706,683732,189847,802380,856527,656421,954913,990024,766868,878463,924390,10125,677894,974605,793981,722664,162770,363993,46031,74976,1032518,73559,778155,732019,501758,986486,293063,283648,366535,759269,699972,935678,422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000750s ]