SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309115 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309115 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289914,788160,782150,288007,991628,46633,797822,47468,423847,1025825,409761,648146,879411,124569,566670,771596,167702,337350,108926,981150,602450,418106,453403,864880,7264,280006,536471,113903,195394,626310,469407,107834,803817,831217,103973,666989,221969,652417,813313,182686,392425,755410,972877,360335,1024514,752735,711463,265057,545756,841697,358777,685956,250869,864326,175380,937318,390586,924526,220978,109081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309115 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309115 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]