SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001659s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331140 LIMIT 1 [ RunTime:0.000806s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331140 [ RunTime:0.003423s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018245,690922,772037,151100,324268,789621,717827,789288,259015,811631,804720,257954,823299,287506,36355,224718,2538,1023503,46831,75101,853924,369138,114615,938381,241196,31804,782099,363648,698381,896839,547685,372438,1032093,963307,796703,811742,585283,157620,706594,422512,239467,12249,526770,79775,617955,867655,996183,95969,99840,47451,912684,446013,422088,209369,934766,104495,367693,139982,533127,763279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001833s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000748s ]