SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470065 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470065 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806378,583116,719734,823507,529272,345707,701763,712313,564456,1028064,640488,377113,7852,455482,738458,221318,126959,855239,626995,1013167,52332,180563,985795,260866,684621,861169,857575,227554,277271,423936,407592,429199,723098,975682,950475,605342,901540,83284,762746,457375,1034324,464627,873737,139885,835329,31607,665253,755732,826476,551154,459331,778760,652409,891497,155221,334644,443667,198435,72300,734856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470065 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470065 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001116s ]