SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425080 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425080 [ RunTime:0.002096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428022,818150,879499,436849,87514,932836,1035035,744818,177442,1025899,313326,537688,331295,39488,806001,795941,502648,1006626,977503,274272,885924,1023071,937722,775099,317573,306322,820365,1028793,915642,731,591939,714669,779046,582356,106261,871323,977167,73023,1000858,226165,707124,473624,333414,903586,513636,144261,705118,488863,85573,823430,784105,568100,192652,653053,214474,414278,246339,575887,713842,494187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000708s ]