SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535916 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535916 [ RunTime:0.002327s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221809,998595,156918,843227,603304,974048,792408,104234,1011021,510107,950888,1007853,1020131,64494,547383,901777,439449,870997,755683,74924,75050,839206,688600,415768,126578,122876,814474,152803,1026586,875380,668673,219539,484327,323750,652993,369586,537802,402744,251471,678367,966847,725478,917177,721540,427417,619656,344553,265560,791469,932043,217940,490662,754891,332985,437367,13080,132159,448665,34571,680107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000756s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000726s ]