SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801674 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801674 [ RunTime:0.003726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402969,249275,1004429,210676,31966,78491,902060,416751,108155,375935,7127,1010866,344333,795770,351972,392960,565175,561015,881300,493703,771044,530655,929892,974465,279231,874420,435649,94847,608707,699678,508968,288033,673567,674166,263691,111278,908874,739991,420238,235013,13127,450523,644245,940504,79614,297102,179942,226469,37196,4737,884731,462861,926667,53222,133913,261488,624130,363211,756833,904682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]