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` = 1047430 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047430 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362415,137318,149299,598366,646034,978289,270023,45204,132183,350916,364308,10506,895887,688239,593508,247751,173764,219626,957191,509569,1046555,708919,837672,644355,733336,1027047,1020288,576095,281098,279132,701608,107468,513623,274699,47155,669191,424589,1024984,846058,986204,645601,764790,559328,205143,338583,562729,277693,300384,833105,1025896,636804,324198,722498,957729,51887,1003809,255261,925792,810808,685459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004828s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]