SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003522s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545091 LIMIT 1 [ RunTime:0.001542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545091 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (884515,31182,10223,940031,519305,580180,634392,527595,908460,77782,243919,885815,68986,612533,433141,110002,906614,881307,499272,341134,96932,141855,105944,340862,777122,669828,483038,714044,982833,1004822,302855,866115,9453,413559,90604,865596,474327,182234,955260,94125,967275,757078,841839,305309,307525,228768,497073,287629,1035750,686752,46993,37317,999028,791026,692544,472973,304208,939095,1003422,31815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002383s ]