SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002058s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542991 LIMIT 1 [ RunTime:0.001151s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542991 [ RunTime:0.002836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598809,108627,948651,766334,571744,698243,3411,537954,281583,72266,198798,739479,505278,9028,766367,754476,432176,97785,423262,836505,630353,178138,867648,892737,762254,128025,698148,455216,558596,633615,936879,38677,569417,1000968,127322,251201,268107,270608,845436,97401,151856,544274,747523,889694,359817,365038,440701,52933,521627,318,893066,318673,996189,658435,840874,769831,994605,771490,258043,516608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]