SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023021 LIMIT 1 [ RunTime:0.001774s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023021 [ RunTime:0.005287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393669,272084,610899,856595,142449,1009211,747761,694784,572604,335530,78487,266099,95344,386194,173532,58787,730428,984202,647881,851049,821224,500009,788021,560617,677189,677463,1024000,709664,981134,568,997845,841025,770111,914628,590013,313831,798189,795429,1048747,914025,158593,634062,617484,568500,116975,827180,591729,918055,573812,943566,242760,315760,921824,604056,985271,844462,351290,838064,1041501,38772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005707s ]