SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266938 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266938 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011102,666381,812333,22858,199701,181313,864400,439868,299411,877904,732961,930597,1033222,83063,721393,70807,22083,991045,327300,100176,281584,1004201,718621,996574,700334,811670,605781,223306,453889,35364,202829,913800,952201,336423,895437,370453,91317,393039,636064,331682,1001472,472391,862587,997587,635858,194945,793714,32258,739320,131656,800691,837817,477906,550986,965455,588868,974288,532870,756222,362980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]