SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001520s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981324 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981324 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142103,550150,717695,266859,331762,301314,165854,1044025,137637,728749,353840,626004,7265,404740,861664,230255,1035791,962258,200547,760197,294088,788548,306148,547432,814840,762282,554941,375480,889085,533937,254786,215136,866622,409525,443799,990338,854355,110349,422156,469859,42834,349393,904314,303711,668104,771631,394949,689712,1041961,669118,539871,2394,640920,642301,457773,926811,911899,685763,43924,880065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981324 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981324 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]