SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531314 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531314 [ RunTime:0.002522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295196,654360,1003951,896371,926340,858226,577715,1029886,131584,794654,701749,308126,587327,959201,759078,537877,420506,1002532,690432,272636,172610,168526,21094,161679,429063,145479,801885,498645,350878,666648,1039792,254554,641897,864844,42438,247890,537531,554287,668328,997920,978292,472802,543936,847475,609242,952029,383857,997604,1043850,1034316,540412,727289,357237,568234,5669,241545,657542,1047134,511476,817269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]