SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 594506 LIMIT 1 [ RunTime:0.003417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 594506 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796442,657557,149964,502413,1040557,202962,606302,183333,586191,17581,95535,351138,456487,43641,103414,198059,571871,500265,313917,285055,865181,38321,131357,21461,545330,762107,38307,1009659,423648,819991,395289,797285,560660,189820,408165,922508,856959,466296,72296,38762,196388,294613,336452,677142,910932,998705,92925,159236,278004,523090,353865,435195,182842,746821,338172,300585,1029368,724402,274829,710078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 594506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 594506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]