SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333028 LIMIT 1 [ RunTime:0.002138s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333028 [ RunTime:0.005215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321390,1013121,189626,186194,1031979,615533,563003,459962,191266,778976,887903,966566,898269,280528,949382,32238,334162,575481,712161,237439,1040205,919672,831459,1021754,81566,578228,516133,117335,873788,613315,916188,806177,358598,724554,830613,1011618,820967,180589,58220,200121,235839,220134,659473,331797,902389,1038696,365545,589371,468681,215248,14892,95698,586279,417696,866984,454925,36760,751352,401040,18076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]