SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510984 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510984 [ RunTime:0.001620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503448,1042231,369033,590053,276619,403326,714992,168030,987500,205428,724167,952113,914853,565914,785337,562878,264875,991152,853884,630078,1030259,8261,315748,285682,946573,641976,770611,328463,291412,1030854,312180,24795,353348,1042629,533471,864350,520875,70939,166957,603717,266273,291530,770448,215923,271801,400160,497357,633750,151282,912693,17993,1028447,345016,91862,70758,369100,955048,1043178,1026913,308256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]