SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476515 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476515 [ RunTime:0.002176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482412,258601,428126,271390,848541,892102,994331,499413,382225,325979,64839,159992,334954,812881,492730,504705,817260,58477,308220,458655,67547,878466,466867,671510,897288,709736,449449,843868,354625,541276,770110,469249,1038582,207407,492385,918381,708946,135472,970485,765698,330933,283938,28920,124434,871553,153122,210163,907214,414915,953767,758700,918646,80346,139581,253471,107266,259707,520072,745873,643164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001284s ]