SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418841 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418841 [ RunTime:0.003098s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583012,563376,830827,850168,522693,554456,813627,377229,99057,26300,763161,1002867,442588,568885,599564,86365,7101,922167,300938,773026,732689,133932,185470,996049,220635,155962,628904,432808,983571,217824,907157,494912,1003104,487536,347708,325904,833501,820416,218190,452936,470504,918445,1004108,891186,634801,4069,463667,487878,839241,759674,405721,602818,212531,164013,959986,33702,205115,77366,512737,781438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]