SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455161 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455161 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911379,472923,469069,527455,18934,587082,612217,759493,1036901,1014522,524687,227576,808299,82589,902177,285304,655610,149595,457314,224012,459997,133525,648692,1029678,778350,124271,433247,950542,142002,23592,78390,115045,895949,633149,995694,693714,92820,83048,604071,360354,760293,893485,743178,547011,600518,201260,600588,813892,903548,428789,698475,886574,693331,770100,385469,120341,114139,944110,521643,955435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000755s ]