SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039316 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039316 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456638,1011667,39125,164901,870160,381712,265217,740591,156421,678498,437505,1042832,554531,365588,14528,893588,672016,173858,533953,1040669,707323,773672,962334,30209,509461,119242,851363,373027,1026459,248448,516579,639765,868082,412913,689652,576854,964669,1009121,928686,569267,995472,494417,369496,926260,535285,552172,194174,829349,218655,849343,616574,158545,483055,830464,901026,575236,768598,406229,298752,450932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]