SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402739 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402739 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430806,219623,1004482,829164,514614,652134,647504,249192,324950,462703,925303,1037961,712917,720051,786317,101987,647077,147504,267601,194514,293316,36640,918762,220825,543745,410584,847419,414756,219202,501452,109333,587914,944504,444688,465319,862189,526958,455074,553339,520809,855360,1032727,771485,891418,912656,802809,397234,615297,885284,39056,448161,862011,694819,566812,579676,810910,57997,682082,196734,965550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402739 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402739 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]