SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502127 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502127 [ RunTime:0.002140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (667851,152939,364415,247510,362787,534412,138352,661931,30026,721303,132064,489897,688710,381004,997507,296151,605109,806050,179395,1007469,381138,393586,1031958,449654,604928,405345,246806,690587,135930,838073,247547,74054,841085,131165,657262,103259,754305,943705,618542,315922,698791,574072,1035779,760011,789227,261948,1011164,990467,557469,656918,968413,264480,777678,531763,419501,539180,626977,436184,396208,837768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502127 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502127 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]