SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281148 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281148 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390082,681911,969558,881809,641274,634022,796076,858008,901757,1024342,778753,484005,695774,580788,814462,166840,1008750,84496,223385,856881,145325,921322,841387,496451,550986,691593,671165,364585,801342,236126,336348,655298,638814,172407,460178,78544,632476,916650,303548,837749,59223,523131,699772,113646,1014775,1015992,845145,402785,714877,462635,747690,856328,1485,817235,538903,282080,295270,657871,838865,715228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]