SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520200 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520200 [ RunTime:0.001435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (884654,704341,82460,373865,994796,481932,474536,704821,535197,4211,219502,28763,1002434,799663,194059,276969,301975,417315,348410,340361,674468,159226,738088,702130,489020,719251,369916,839522,53039,439546,342394,668667,932860,1742,90327,962098,116102,235039,835235,929206,308290,180195,884008,139147,416386,28790,841036,515054,177870,120564,65858,696055,300457,96589,108678,509572,64394,460462,292157,700828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]