SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522474 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522474 [ RunTime:0.001429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (227440,449885,608140,477714,601728,811069,250526,1034807,492769,455178,356533,49290,136721,38203,141615,943584,1027957,605701,684077,573313,142845,192204,793854,108126,767708,193442,739384,347242,69134,1017162,814192,875571,156203,896402,230547,635062,112803,497756,828195,37241,683950,282049,180297,950065,3119,235767,672431,378827,376540,628285,456248,779181,240081,1035200,357146,658174,952078,866928,311850,19229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]