SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003942s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335399 LIMIT 1 [ RunTime:0.001403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335399 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981262,764431,815139,265599,420763,411100,984674,80618,479410,546556,976143,756329,1021790,896801,315413,32031,234964,398960,622775,166648,695080,553957,1040796,914933,1000755,707453,780099,879524,127647,666862,912654,879448,38764,154249,357847,614322,434501,393358,900976,731630,645201,270261,629815,586387,684192,626460,635307,1041276,447025,352623,603685,44872,185223,22170,860035,837965,144137,4309,311043,876054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007072s ]