SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396104 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396104 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406101,468757,115145,525045,369972,391083,343964,418688,405860,817726,219987,796696,331375,625978,788605,595331,572888,455752,291515,606304,565034,557166,475892,109482,470810,542471,719425,43931,19616,649151,962490,361901,605790,638329,813373,672638,240047,430943,294349,686421,157232,155517,355927,456782,819726,160646,296265,144108,137850,413007,187718,263383,271875,998388,228365,260587,311348,997926,82062,349692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001488s ]