SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001733s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42515 LIMIT 1 [ RunTime:0.000871s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42515 [ RunTime:0.002571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892592,452303,343985,423157,457991,921270,1033139,260726,650305,3800,650214,151660,1002451,145468,380396,383506,332540,1581,462994,657239,679859,323685,21221,552642,283652,602541,728307,298751,275054,102460,614404,636231,97212,150799,486722,676290,495418,650597,865318,538239,672009,672899,697200,230601,194078,543389,877429,681344,583733,554686,371571,213176,942458,511449,248301,1043650,437094,880152,601926,724911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000388s ]