SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485286 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485286 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527050,402926,592450,412190,952333,802123,852917,347968,900426,310326,296717,119559,389780,182459,658416,295597,921111,515427,891207,683874,348887,995402,470376,31501,412836,278328,797351,517285,680544,910576,747736,543180,406925,218714,54812,317395,256166,796060,318457,502619,231601,296922,256954,627996,858481,615652,965413,375795,98356,740422,728894,188535,354637,282550,975795,523034,758487,108014,310257,173485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485286 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485286 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000745s ]