SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001475s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405521 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405521 [ RunTime:0.003191s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432582,912668,547736,309848,814451,797103,676385,178254,562882,557303,838095,368719,508147,242531,218224,865456,544842,296800,604721,743020,982167,519254,511596,803152,255702,698870,597591,331621,1007826,243227,125157,324701,114098,74342,845412,389388,61297,996759,857551,476735,188776,990288,24908,135994,722346,24280,252794,183076,395935,505516,963803,243770,976594,469236,819088,655623,125899,788696,805417,777105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000717s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]