SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001575s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 135107 LIMIT 1 [ RunTime:0.000725s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 135107 [ RunTime:0.003882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413625,397222,196448,577941,678100,77413,60991,544291,926916,169084,947026,347447,724669,226181,357135,678280,178705,173327,806039,1029471,1034176,106074,861610,639411,699247,911448,223500,495904,411566,23165,27745,308229,823274,608691,772537,850418,624560,892756,670761,398120,265116,300360,394028,986229,902039,98840,280305,201230,760843,36742,722000,540904,254329,380908,243980,660859,785922,1033185,976337,826587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001736s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 135107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000760s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 135107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001547s ]