SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028840 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028840 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665890,748592,970459,431641,882406,156727,290068,273970,232087,386988,968226,940952,549680,872109,27313,414165,411481,51206,675100,1040740,613422,828769,428824,882521,532955,715516,834918,236738,101791,27355,588067,140416,1031903,984102,482086,490916,265937,240079,551851,899126,940690,174946,909231,394056,146332,237980,330268,89218,491664,473302,112109,841954,960666,74991,306250,308308,14927,915074,1035917,54719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]