SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502211 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502211 [ RunTime:0.001453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237438,936960,531023,1023995,402919,409827,359358,1041289,649256,593044,433024,391139,80849,291954,8818,57253,593422,1004603,272906,740361,592231,491566,16396,232676,423875,933435,227614,973450,508340,292447,6134,49172,137402,772545,1005905,437340,966501,887439,889512,939818,483919,837139,39982,117157,678387,6117,466618,191078,740990,182433,746598,66460,33677,998146,980533,669896,526686,713768,1004171,51947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]