SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001543s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543803 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543803 [ RunTime:0.003270s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (667943,288767,737943,812836,1034116,437602,1039293,440808,955850,586750,220015,643875,437094,838361,509150,929736,818487,583623,458484,536311,472520,819084,837239,993824,6304,517668,312543,631931,994486,1044742,637438,366217,299746,47411,526105,86288,696089,611339,615697,282799,498111,754697,825606,819529,312377,462138,826018,360297,1015230,697376,807201,568204,964888,359043,280108,949406,727850,169863,611839,615730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]