SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108103 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108103 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252893,507110,961457,27259,360133,197641,211653,277879,614106,830263,272161,86211,383975,802892,332579,170773,180587,955144,635875,310627,486000,316062,819467,234042,259762,197873,401133,582134,923291,898438,790989,286751,1017937,294563,529085,190097,218338,406720,817152,256193,8762,469273,312326,126802,10637,486379,248036,364681,738012,777766,15347,792807,289281,708409,613988,981156,339169,722925,460482,613131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000887s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]