SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 174203 LIMIT 1 [ RunTime:0.000608s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 174203 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102346,339848,433246,926332,478576,100326,602314,634856,357902,469924,326865,473722,297474,504955,167067,683386,275262,54993,41081,143746,927315,610758,385420,116553,548615,771811,235198,145333,871960,630828,675312,235360,195284,316185,845899,728980,588161,367762,364173,112094,989571,851943,478424,224818,983312,299826,201669,30150,440564,689470,1037018,229360,1003774,766641,559753,947438,782293,533767,883946,371767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 174203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 174203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]